Tabela PrescriptionDrug

Definicja tabeli PrescriptionDrug

Name

PrescriptionDrug

Code

PrescriptionDrug

Comment

Lek na recepcie


Lista kolumn tabeli PrescriptionDrug

Name

Code

PrescriptionDrugID

PrescriptionDrugID

PrescriptionID

PrescriptionID

PackCount

PackCount

NoSubstitute

NoSubstitute

Comments

Comments

DrugValue

DrugValue

DosageID

DosageID

CostGroup

CostGroup

DrugCount

DrugCount

DosageQuantity

DosageQuantity

DosageQuantityUnit

DosageQuantityUnit

ePrescriptionCode

ePrescriptionCode

ePrescriptionStatus

ePrescriptionStatus


Kolumna PrescriptionDrugID tabeli PrescriptionDrug

Definicja kolumny PrescriptionDrugID tabeli PrescriptionDrug

Name

PrescriptionDrugID

Code

PrescriptionDrugID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PrescriptionID tabeli PrescriptionDrug

Definicja kolumny PrescriptionID tabeli PrescriptionDrug

Name

PrescriptionID

Code

PrescriptionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PackCount tabeli PrescriptionDrug

Definicja kolumny PackCount tabeli PrescriptionDrug

Name

PackCount

Code

PackCount

Data Type

NUMBER(10)

Mandatory

No

Comment

Ilosc opakowan


Kolumna NoSubstitute tabeli PrescriptionDrug

Definicja kolumny NoSubstitute tabeli PrescriptionDrug

Name

NoSubstitute

Code

NoSubstitute

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Nie zamieniac


Kolumna Comments tabeli PrescriptionDrug

Definicja kolumny Comments tabeli PrescriptionDrug

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Komentarz


Kolumna DrugValue tabeli PrescriptionDrug

Definicja kolumny DrugValue tabeli PrescriptionDrug

Name

DrugValue

Code

DrugValue

Data Type

VARCHAR2(256)

Mandatory

No

Comment

Materializacja danych o leku. Wartosc do prezentacji na wydruku recepty.


Kolumna DosageID tabeli PrescriptionDrug

Definicja kolumny DosageID tabeli PrescriptionDrug

Name

DosageID

Code

DosageID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CostGroup tabeli PrescriptionDrug

Definicja kolumny CostGroup tabeli PrescriptionDrug

Name

CostGroup

Code

CostGroup

Data Type

VARCHAR2(4)

Mandatory

No

Comment

Ddplatnosc za lek 30%|50%|100%|R|B R - ryczalt, B - Bezplatnie


Kolumna DrugCount tabeli PrescriptionDrug

Definicja kolumny DrugCount tabeli PrescriptionDrug

Name

DrugCount

Code

DrugCount

Data Type

NUMBER(10)

Mandatory

No

Comment

Ilosc przepisanego leku dla niepelnych opakowan


Kolumna DosageQuantity tabeli PrescriptionDrug

Definicja kolumny DosageQuantity tabeli PrescriptionDrug

Name

DosageQuantity

Code

DosageQuantity

Data Type

NUMBER(18,8)

Mandatory

No

Comment

Sumaryczna ilosc przepisanej dawki (jednorazowa dawka * ilosc opakowan * ilosc sztuk).


Kolumna DosageQuantityUnit tabeli PrescriptionDrug

Definicja kolumny DosageQuantityUnit tabeli PrescriptionDrug

Name

DosageQuantityUnit

Code

DosageQuantityUnit

Data Type

VARCHAR2(10)

Mandatory

No

Comment

Jednostka przepisanej dawki


Kolumna ePrescriptionCode tabeli PrescriptionDrug

Definicja kolumny ePrescriptionCode tabeli PrescriptionDrug

Name

ePrescriptionCode

Code

ePrescriptionCode

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Kod e-recepty


Kolumna ePrescriptionStatus tabeli PrescriptionDrug

Definicja kolumny ePrescriptionStatus tabeli PrescriptionDrug

Name

ePrescriptionStatus

Code

ePrescriptionStatus

Data Type

VARCHAR2(10)

Mandatory

No

Comment

status e-recepty


Lista kluczy tabeli PrescriptionDrug

Name

Code

Primary

PK_PrescriptionDrug

PK_PrescriptionDrug

X


Klucz PK_PrescriptionDrug tabeli PrescriptionDrug

Definicja klucza PK_PrescriptionDrug tabeli PrescriptionDrug

Name

PK_PrescriptionDrug

Code

PK_PrescriptionDrug

Primary

Yes

Comment